Home > mailing lists

Re: [SQL] Can I prevent my sequence to increment if an insert isrejected? - Mailing list pgsql-sql

From	Herouth Maoz
Subject	Re: [SQL] Can I prevent my sequence to increment if an insert isrejected?
Date	July 21, 1999 08:45:09
Msg-id	l03130302b3bb46f98fd9@[147.233.159.109] Whole thread Raw
In response to	Re: [SQL] Can I prevent my sequence to increment if an insert isrejected? (Chris Bitmead <chris@tech.com.au>)
List	pgsql-sql

Tree view

At 12:36 +0300 on 21/07/1999, Chris Bitmead wrote:


> I missed the original question, but don't you get sequential numbers as
> long as cache is 0?

No. If an insert failed or a transaction failed, the sequence remains in
its new state.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma

pgsql-sql by date:

From: Chris Bitmead
Date: 21 July 1999, 08:38:09
Subject: Re: [SQL] Can I prevent my sequence to increment if an insert isrejected?

From: "Jonathan davis"
Date: 21 July 1999, 08:46:09
Subject: pb with pg_group

Re: [SQL] Can I prevent my sequence to increment if an insert isrejected? - Mailing list pgsql-sql

Previous

Next